package app.common.dao;
import java.util.ArrayList;
import java.util.List;

import cn.lily.com.container.data.Record;
import cn.lily.com.exception.YaconException;
import cn.lily.esb.framework.drivers.db.bean.ControlDAO;
public class Leo_can_report_allBean extends ControlDAO implements Cloneable {
	private static final long serialVersionUID = 1L;
	public Leo_can_report_allBean() throws YaconException {
		super();
		setTableName("LEO_CAN_REPORT_ALL");
	}
	String  fcan_name_memo;
	String  fcan_name_other;
	String  fcan_id;
	String  fcan_detail_name;
	String  fcan_first;
	String  fcan_month;
	String  fcan_fans;
	String  fres_tag_memo;
	String  fcan_year;
	String  fcan_size;
	String  fcan_time;
	String  fcan_total;
	String  fdisk_id;
	String  fcan_demo;
	String  fcan_firm_memo;
	String  fcan_nam_eng;
	String  fcan_nam_jap;
	String  fcan_typ_memo;
	String  fcan_name;
	String  fres_id;
	String  fcan_kind;
	String  fcan_qua;
	String  fres_store_place;
	String  fres_store_size;
	String  fcan_stat;
	String  fcan_detail_id;
	String  fcan_area;
	String  fcan_source;

	public void setCan_name_memo( String can_name_memo)throws YaconException{
		setFieldData("can_name_memo",can_name_memo,TEXT);
		this.fcan_name_memo=can_name_memo;
	}

	public String getCan_name_memo(){
		if ( this.fcan_name_memo == null){
			return "";
		}
		else {
			return this.fcan_name_memo;
		}
	}

	public void setCan_name_other( String can_name_other)throws YaconException{
		setFieldData("can_name_other",can_name_other,TEXT);
		this.fcan_name_other=can_name_other;
	}

	public String getCan_name_other(){
		if ( this.fcan_name_other == null){
			return "";
		}
		else {
			return this.fcan_name_other;
		}
	}

	public void setCan_id( String can_id)throws YaconException{
		setFieldData("can_id",can_id,TEXT);
		this.fcan_id=can_id;
	}

	public String getCan_id(){
		if ( this.fcan_id == null){
			return "";
		}
		else {
			return this.fcan_id;
		}
	}

	public void setCan_detail_name( String can_detail_name)throws YaconException{
		setFieldData("can_detail_name",can_detail_name,TEXT);
		this.fcan_detail_name=can_detail_name;
	}

	public String getCan_detail_name(){
		if ( this.fcan_detail_name == null){
			return "";
		}
		else {
			return this.fcan_detail_name;
		}
	}

	public void setCan_first( String can_first)throws YaconException{
		setFieldData("can_first",can_first,TEXT);
		this.fcan_first=can_first;
	}

	public String getCan_first(){
		if ( this.fcan_first == null){
			return "";
		}
		else {
			return this.fcan_first;
		}
	}

	public void setCan_month( String can_month)throws YaconException{
		setFieldData("can_month",can_month,TEXT);
		this.fcan_month=can_month;
	}

	public String getCan_month(){
		if ( this.fcan_month == null){
			return "";
		}
		else {
			return this.fcan_month;
		}
	}

	public void setCan_fans( String can_fans)throws YaconException{
		setFieldData("can_fans",can_fans,TEXT);
		this.fcan_fans=can_fans;
	}

	public String getCan_fans(){
		if ( this.fcan_fans == null){
			return "";
		}
		else {
			return this.fcan_fans;
		}
	}

	public void setRes_tag_memo( String res_tag_memo)throws YaconException{
		setFieldData("res_tag_memo",res_tag_memo,TEXT);
		this.fres_tag_memo=res_tag_memo;
	}

	public String getRes_tag_memo(){
		if ( this.fres_tag_memo == null){
			return "";
		}
		else {
			return this.fres_tag_memo;
		}
	}

	public void setCan_year( String can_year)throws YaconException{
		setFieldData("can_year",can_year,TEXT);
		this.fcan_year=can_year;
	}

	public String getCan_year(){
		if ( this.fcan_year == null){
			return "";
		}
		else {
			return this.fcan_year;
		}
	}

	public void setCan_size( String can_size)throws YaconException{
		setFieldData("can_size",can_size,TEXT);
		this.fcan_size=can_size;
	}

	public String getCan_size(){
		if ( this.fcan_size == null){
			return "";
		}
		else {
			return this.fcan_size;
		}
	}

	public void setCan_time( String can_time)throws YaconException{
		setFieldData("can_time",can_time,DATE);
		this.fcan_time=can_time;
	}

	public String getCan_time(){
		if ( this.fcan_time == null){
			return "";
		}
		else {
			return this.fcan_time;
		}
	}

	public void setCan_total( String can_total)throws YaconException{
		setFieldData("can_total",can_total,TEXT);
		this.fcan_total=can_total;
	}

	public String getCan_total(){
		if ( this.fcan_total == null){
			return "";
		}
		else {
			return this.fcan_total;
		}
	}

	public void setDisk_id( String disk_id)throws YaconException{
		setFieldData("disk_id",disk_id,TEXT);
		this.fdisk_id=disk_id;
	}

	public String getDisk_id(){
		if ( this.fdisk_id == null){
			return "";
		}
		else {
			return this.fdisk_id;
		}
	}

	public void setCan_demo( String can_demo)throws YaconException{
		setFieldData("can_demo",can_demo,TEXT);
		this.fcan_demo=can_demo;
	}

	public String getCan_demo(){
		if ( this.fcan_demo == null){
			return "";
		}
		else {
			return this.fcan_demo;
		}
	}

	public void setCan_firm_memo( String can_firm_memo)throws YaconException{
		setFieldData("can_firm_memo",can_firm_memo,TEXT);
		this.fcan_firm_memo=can_firm_memo;
	}

	public String getCan_firm_memo(){
		if ( this.fcan_firm_memo == null){
			return "";
		}
		else {
			return this.fcan_firm_memo;
		}
	}

	public void setCan_nam_eng( String can_nam_eng)throws YaconException{
		setFieldData("can_nam_eng",can_nam_eng,TEXT);
		this.fcan_nam_eng=can_nam_eng;
	}

	public String getCan_nam_eng(){
		if ( this.fcan_nam_eng == null){
			return "";
		}
		else {
			return this.fcan_nam_eng;
		}
	}

	public void setCan_nam_jap( String can_nam_jap)throws YaconException{
		setFieldData("can_nam_jap",can_nam_jap,TEXT);
		this.fcan_nam_jap=can_nam_jap;
	}

	public String getCan_nam_jap(){
		if ( this.fcan_nam_jap == null){
			return "";
		}
		else {
			return this.fcan_nam_jap;
		}
	}

	public void setCan_typ_memo( String can_typ_memo)throws YaconException{
		setFieldData("can_typ_memo",can_typ_memo,TEXT);
		this.fcan_typ_memo=can_typ_memo;
	}

	public String getCan_typ_memo(){
		if ( this.fcan_typ_memo == null){
			return "";
		}
		else {
			return this.fcan_typ_memo;
		}
	}

	public void setCan_name( String can_name)throws YaconException{
		setFieldData("can_name",can_name,TEXT);
		this.fcan_name=can_name;
	}

	public String getCan_name(){
		if ( this.fcan_name == null){
			return "";
		}
		else {
			return this.fcan_name;
		}
	}

	public void setRes_id( String res_id)throws YaconException{
		setFieldData("res_id",res_id,TEXT);
		this.fres_id=res_id;
	}

	public String getRes_id(){
		if ( this.fres_id == null){
			return "";
		}
		else {
			return this.fres_id;
		}
	}

	public void setCan_kind( String can_kind)throws YaconException{
		setFieldData("can_kind",can_kind,TEXT);
		this.fcan_kind=can_kind;
	}

	public String getCan_kind(){
		if ( this.fcan_kind == null){
			return "";
		}
		else {
			return this.fcan_kind;
		}
	}

	public void setCan_qua( String can_qua)throws YaconException{
		setFieldData("can_qua",can_qua,TEXT);
		this.fcan_qua=can_qua;
	}

	public String getCan_qua(){
		if ( this.fcan_qua == null){
			return "";
		}
		else {
			return this.fcan_qua;
		}
	}

	public void setRes_store_place( String res_store_place)throws YaconException{
		setFieldData("res_store_place",res_store_place,TEXT);
		this.fres_store_place=res_store_place;
	}

	public String getRes_store_place(){
		if ( this.fres_store_place == null){
			return "";
		}
		else {
			return this.fres_store_place;
		}
	}

	public void setRes_store_size( String res_store_size)throws YaconException{
		setFieldData("res_store_size",res_store_size,TEXT);
		this.fres_store_size=res_store_size;
	}

	public String getRes_store_size(){
		if ( this.fres_store_size == null){
			return "";
		}
		else {
			return this.fres_store_size;
		}
	}

	public void setCan_stat( String can_stat)throws YaconException{
		setFieldData("can_stat",can_stat,TEXT);
		this.fcan_stat=can_stat;
	}

	public String getCan_stat(){
		if ( this.fcan_stat == null){
			return "";
		}
		else {
			return this.fcan_stat;
		}
	}

	public void setCan_detail_id( String can_detail_id)throws YaconException{
		setFieldData("can_detail_id",can_detail_id,TEXT);
		this.fcan_detail_id=can_detail_id;
	}

	public String getCan_detail_id(){
		if ( this.fcan_detail_id == null){
			return "";
		}
		else {
			return this.fcan_detail_id;
		}
	}

	public void setCan_area( String can_area)throws YaconException{
		setFieldData("can_area",can_area,TEXT);
		this.fcan_area=can_area;
	}

	public String getCan_area(){
		if ( this.fcan_area == null){
			return "";
		}
		else {
			return this.fcan_area;
		}
	}

	public void setCan_source( String can_source)throws YaconException{
		setFieldData("can_source",can_source,TEXT);
		this.fcan_source=can_source;
	}

	public String getCan_source(){
		if ( this.fcan_source == null){
			return "";
		}
		else {
			return this.fcan_source;
		}
	}

	public  List<Leo_can_report_allBean> findListBeans(String sSqlWhere)throws YaconException {
		List<Leo_can_report_allBean> listBeans = new ArrayList<Leo_can_report_allBean>();
		findTable = findTableByWhere(sSqlWhere);
		while (findTable.next())
		{
			Leo_can_report_allBean fDaoBean  = new Leo_can_report_allBean();
			fDaoBean.fcan_name_memo = findTable.getString("can_name_memo");
			fDaoBean.fcan_name_other = findTable.getString("can_name_other");
			fDaoBean.fcan_id = findTable.getString("can_id");
			fDaoBean.fcan_detail_name = findTable.getString("can_detail_name");
			fDaoBean.fcan_first = findTable.getString("can_first");
			fDaoBean.fcan_month = findTable.getString("can_month");
			fDaoBean.fcan_fans = findTable.getString("can_fans");
			fDaoBean.fres_tag_memo = findTable.getString("res_tag_memo");
			fDaoBean.fcan_year = findTable.getString("can_year");
			fDaoBean.fcan_size = findTable.getString("can_size");
			fDaoBean.fcan_time = findTable.getString("can_time");
			fDaoBean.fcan_total = findTable.getString("can_total");
			fDaoBean.fdisk_id = findTable.getString("disk_id");
			fDaoBean.fcan_demo = findTable.getString("can_demo");
			fDaoBean.fcan_firm_memo = findTable.getString("can_firm_memo");
			fDaoBean.fcan_nam_eng = findTable.getString("can_nam_eng");
			fDaoBean.fcan_nam_jap = findTable.getString("can_nam_jap");
			fDaoBean.fcan_typ_memo = findTable.getString("can_typ_memo");
			fDaoBean.fcan_name = findTable.getString("can_name");
			fDaoBean.fres_id = findTable.getString("res_id");
			fDaoBean.fcan_kind = findTable.getString("can_kind");
			fDaoBean.fcan_qua = findTable.getString("can_qua");
			fDaoBean.fres_store_place = findTable.getString("res_store_place");
			fDaoBean.fres_store_size = findTable.getString("res_store_size");
			fDaoBean.fcan_stat = findTable.getString("can_stat");
			fDaoBean.fcan_detail_id = findTable.getString("can_detail_id");
			fDaoBean.fcan_area = findTable.getString("can_area");
			fDaoBean.fcan_source = findTable.getString("can_source");
			fDaoBean.operate_mode = "edit";
			listBeans.add(fDaoBean);
		}
		return listBeans;
	}

	public Leo_can_report_allBean findBean(String sSqlWhere)throws YaconException {
		findTable = findTableByWhere(sSqlWhere);
		if (findTable.next())
		{
			Leo_can_report_allBean fDaoBean  = new Leo_can_report_allBean();
			fDaoBean.fcan_name_memo = findTable.getString("can_name_memo");
			fDaoBean.fcan_name_other = findTable.getString("can_name_other");
			fDaoBean.fcan_id = findTable.getString("can_id");
			fDaoBean.fcan_detail_name = findTable.getString("can_detail_name");
			fDaoBean.fcan_first = findTable.getString("can_first");
			fDaoBean.fcan_month = findTable.getString("can_month");
			fDaoBean.fcan_fans = findTable.getString("can_fans");
			fDaoBean.fres_tag_memo = findTable.getString("res_tag_memo");
			fDaoBean.fcan_year = findTable.getString("can_year");
			fDaoBean.fcan_size = findTable.getString("can_size");
			fDaoBean.fcan_time = findTable.getString("can_time");
			fDaoBean.fcan_total = findTable.getString("can_total");
			fDaoBean.fdisk_id = findTable.getString("disk_id");
			fDaoBean.fcan_demo = findTable.getString("can_demo");
			fDaoBean.fcan_firm_memo = findTable.getString("can_firm_memo");
			fDaoBean.fcan_nam_eng = findTable.getString("can_nam_eng");
			fDaoBean.fcan_nam_jap = findTable.getString("can_nam_jap");
			fDaoBean.fcan_typ_memo = findTable.getString("can_typ_memo");
			fDaoBean.fcan_name = findTable.getString("can_name");
			fDaoBean.fres_id = findTable.getString("res_id");
			fDaoBean.fcan_kind = findTable.getString("can_kind");
			fDaoBean.fcan_qua = findTable.getString("can_qua");
			fDaoBean.fres_store_place = findTable.getString("res_store_place");
			fDaoBean.fres_store_size = findTable.getString("res_store_size");
			fDaoBean.fcan_stat = findTable.getString("can_stat");
			fDaoBean.fcan_detail_id = findTable.getString("can_detail_id");
			fDaoBean.fcan_area = findTable.getString("can_area");
			fDaoBean.fcan_source = findTable.getString("can_source");
			fDaoBean.operate_mode = "edit";
			return fDaoBean;
		}else
			return null;
	}

	public void setViewRecord(Record viewRecord) throws YaconException{
		if (viewRecord.getString("can_name_memo") != null)
			setCan_name_memo(viewRecord.getString("can_name_memo"));
		if (viewRecord.getString("can_name_other") != null)
			setCan_name_other(viewRecord.getString("can_name_other"));
		if (viewRecord.getString("can_id") != null)
			setCan_id(viewRecord.getString("can_id"));
		if (viewRecord.getString("can_detail_name") != null)
			setCan_detail_name(viewRecord.getString("can_detail_name"));
		if (viewRecord.getString("can_first") != null)
			setCan_first(viewRecord.getString("can_first"));
		if (viewRecord.getString("can_month") != null)
			setCan_month(viewRecord.getString("can_month"));
		if (viewRecord.getString("can_fans") != null)
			setCan_fans(viewRecord.getString("can_fans"));
		if (viewRecord.getString("res_tag_memo") != null)
			setRes_tag_memo(viewRecord.getString("res_tag_memo"));
		if (viewRecord.getString("can_year") != null)
			setCan_year(viewRecord.getString("can_year"));
		if (viewRecord.getString("can_size") != null)
			setCan_size(viewRecord.getString("can_size"));
		if (viewRecord.getString("can_time") != null)
			setCan_time(viewRecord.getString("can_time"));
		if (viewRecord.getString("can_total") != null)
			setCan_total(viewRecord.getString("can_total"));
		if (viewRecord.getString("disk_id") != null)
			setDisk_id(viewRecord.getString("disk_id"));
		if (viewRecord.getString("can_demo") != null)
			setCan_demo(viewRecord.getString("can_demo"));
		if (viewRecord.getString("can_firm_memo") != null)
			setCan_firm_memo(viewRecord.getString("can_firm_memo"));
		if (viewRecord.getString("can_nam_eng") != null)
			setCan_nam_eng(viewRecord.getString("can_nam_eng"));
		if (viewRecord.getString("can_nam_jap") != null)
			setCan_nam_jap(viewRecord.getString("can_nam_jap"));
		if (viewRecord.getString("can_typ_memo") != null)
			setCan_typ_memo(viewRecord.getString("can_typ_memo"));
		if (viewRecord.getString("can_name") != null)
			setCan_name(viewRecord.getString("can_name"));
		if (viewRecord.getString("res_id") != null)
			setRes_id(viewRecord.getString("res_id"));
		if (viewRecord.getString("can_kind") != null)
			setCan_kind(viewRecord.getString("can_kind"));
		if (viewRecord.getString("can_qua") != null)
			setCan_qua(viewRecord.getString("can_qua"));
		if (viewRecord.getString("res_store_place") != null)
			setRes_store_place(viewRecord.getString("res_store_place"));
		if (viewRecord.getString("res_store_size") != null)
			setRes_store_size(viewRecord.getString("res_store_size"));
		if (viewRecord.getString("can_stat") != null)
			setCan_stat(viewRecord.getString("can_stat"));
		if (viewRecord.getString("can_detail_id") != null)
			setCan_detail_id(viewRecord.getString("can_detail_id"));
		if (viewRecord.getString("can_area") != null)
			setCan_area(viewRecord.getString("can_area"));
		if (viewRecord.getString("can_source") != null)
			setCan_source(viewRecord.getString("can_source"));
	}

}
